import csv
import sqlite3

connection = sqlite3.connect('../db.sqlite3')
cursor = connection.cursor()

create_table = '''
create table data_Mboard
(
    Name text not null,
    ID text not null,
    PID text not null,
    Platform text not null,
    Price text,
    CPUType text,
    Size text,
    Chipset text,
    MemoryType text,
    StorageType text,
    WIFI text,
    GraphicsType text,
    constraint motherboard_pk
        primary key (Name,ID,PID,Platform)
);

'''

cursor.execute(create_table)
file = open('../GetInfo/Details/MboardInfo.csv', encoding='utf-8')
contents = csv.reader(file)
insert_records = "INSERT INTO data_Mboard (Name,ID,PID,Platform,Price,CPUType,Size,Chipset,MemoryType,StorageType,WIFI,GraphicsType) " \
                 "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

cursor.executemany(insert_records, contents)
select_all = "SELECT * FROM data_Mboard"
rows = cursor.execute(select_all).fetchall()
for r in rows:
    print(r)

# Committing the changes
connection.commit()
connection.close()
